SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Procedure [dbo].[spSuaNhanVien](@maNV int,@tenNV nvarchar(50), @cMND char(9),@diaChi nvarchar(100),@sDT varchar(15),@ngaySinh datetime ,@maLoaiNV int,@maNH int,@ngayLam datetime,@usename nvarchar(50),@password nvarchar(50),@login int)
As
Begin
	Update NhanVien
		Set
			TenNV = @tenNV,
			CMND = @cMND,
			DiaChi = @diaChi,
			SDT = @sDT,
			NgaySinh =@ngaySinh,
			MaLoaiNV = @maLoaiNV,
			NgayLam = @ngayLam,
			Usemame = @usename,
			Password = @password,
			Login = @login
			

		Where MaNV = @maNV
End